package com.agu.utils;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.WordUtils;
import org.springframework.util.ResourceUtils;

import com.agu.entity.ColumnEntity;
import com.agu.entity.TableEntity;
import com.agu.mgt.sys.dto.CodeVo;

import freemarker.template.Template;

/**
 * 代码生成器 工具类
 * 
 */
public class GenUtils {

	public static List<String> getTemplates() {
		List<String> templates = new ArrayList<String>();
		//templates.add("template/Entity.java.vm");
		//templates.add("template/Dao.java.vm");
		//templates.add("template/Dao.xml.vm");
		//templates.add("template/Service.java.vm");
		//templates.add("template/ServiceImpl.java.vm");
		//templates.add("template/Controller.java.vm");
		//templates.add("template/list.html.ftl");
		templates.add("list.js.ftl");
		//templates.add("template/menu.sql.vm");
		return templates;
	}

	public static void generatorCode(Map<String, String> table, List<Map<String, String>> columns,
			ZipOutputStream zip) {
		generatorCode(table, columns, zip, null);
	}

	/**
	 * 生成代码
	 */
	public static void generatorCode(Map<String, String> table, List<Map<String, String>> columns, ZipOutputStream zip,
			CodeVo cc) {
		// 配置信息
		Configuration config = getConfig();

		if (cc != null) {
			config.setProperty("basePackage", cc.getBasePackage());
			config.setProperty("platPackage", cc.getPlatPackage());
			config.setProperty("modulePackage", cc.getModulePackage());
			config.setProperty("author", cc.getAuthor());
			config.setProperty("email", cc.getEmail());
		}

		// 表信息
		TableEntity tableEntity = new TableEntity();
		tableEntity.setTableName(table.get("tableName"));
		tableEntity.setComments(table.get("tableComment"));
		// 表名转换成Java类名
		String className = tableToJava(tableEntity.getTableName(), config.getString("tablePrefix"));
		tableEntity.setClassName(className);
		tableEntity.setClassname(StringUtils.uncapitalize(className));

		// 列信息
		List<ColumnEntity> columsList = new ArrayList<>();
		for (Map<String, String> column : columns) {
			ColumnEntity columnEntity = new ColumnEntity();
			columnEntity.setColumnName(column.get("columnName").toLowerCase());
			columnEntity.setDataType(column.get("dataType"));
			columnEntity.setComments(column.get("columnComment"));
			columnEntity.setShortComments(column.get("shortComment"));
			columnEntity.setExtra(column.get("extra"));
			Object dataPrecision =  column.get("dataPrecision");
			if(dataPrecision != null)
			{
				columnEntity.setDataPrecision(((BigDecimal)dataPrecision).intValue());
			}else {
				columnEntity.setDataPrecision(0);
			}
			
			Object dataScale =  column.get("dataScale");
			if(dataScale != null)
			{
				columnEntity.setDataScale(((BigDecimal)dataScale).intValue());
			}else {
				columnEntity.setDataScale(0);
			}

			if("NUMBER".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=NUMERIC");
				
				if(columnEntity.getDataPrecision()>10 && columnEntity.getDataScale() == 0)
				{
					columnEntity.setDataType("NUMBERL");
				}
				
				if(columnEntity.getDataPrecision()>10 && columnEntity.getDataScale() > 0)
				{
					columnEntity.setDataType("NUMBERF");
				}
				
				if(columnEntity.getDataPrecision()>15 && columnEntity.getDataScale() > 0)
				{
					columnEntity.setDataType("NUMBERD");
				}
				
			}
			if("VARCHAR2".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=VARCHAR");
			}
			if("VARCHAR".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=VARCHAR");
			}
			if("CLOB".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=VARCHAR");
			}
			if("DATE".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=DATE");
			}
			if("TIMESTAMP".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=DATE");
			}
			if("TIMESTAMP(6)".equals(columnEntity.getDataType()))
			{
				columnEntity.setJdbcType("jdbcType=DATE");
			}
			
			
			String comment=null;
			String inputType=null;
			boolean nolist=false;
			boolean noinput=false;
			boolean noview=false;
			HashMap<String, Map> map=null;
			String mapName=null;
			String mapString=null;
			String commentLong = column.get("columnComment");
			

			
			
			if(commentLong!=null)
			{
				int i = commentLong.indexOf("|");

	            if (i <= 0) {
	                comment = commentLong;
	            } else {
	                comment = commentLong.substring(0, i).trim();
	                //nolist noinput noview
	                if (commentLong.contains("nolist")) {
	                    nolist = true;
	                    commentLong = commentLong.replaceAll("nolist", "").trim();
	                }
	                if (commentLong.contains("noinput")) {
	                    noinput = true;
	                    commentLong = commentLong.replaceAll("noinput", "").trim();
	                }
	                if (commentLong.contains("noview")) {
	                    noview = true;
	                    commentLong = commentLong.replaceAll("noview", "").trim();
	                }

	                if (i + 1 < commentLong.length()) {
	                    String tempString = commentLong.substring(i + 1).trim();

	                    int j = tempString.indexOf("@");
	                    if (j > 0 && j < tempString.length()) {
	                        inputType = tempString.substring(0, j);

	                        map = new HashMap<String, Map>();
	                        if (j + 1 < tempString.length()) {
	                            mapString = tempString.substring(j + 1);
	                            int k = mapString.indexOf("#");
	                            if (k > 0 && k + 1 < mapString.length()) {
	                                mapName = mapString.substring(0, k);
	                                mapString = mapString.substring(k + 1);

	                               Map map1 = FiledUtil.strToMap(mapString);
	                                if(map1!=null) {
	                                    map.put(mapName, map1);
	                                }
	                            }
	                        }
	                    }
	                }
	            }
			}
			columnEntity.setInputType(inputType);
			columnEntity.setMapName(mapName);
			columnEntity.setNolist(nolist);
			columnEntity.setNoinput(noinput);
			columnEntity.setNoview(noview);
			columnEntity.setMapString(mapString);
			columnEntity.setMap(map);
			
			
			// 列名转换成Java属性名
			String attrName = columnToJava(columnEntity.getColumnName());
			columnEntity.setAttrName(attrName);
			columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

			// 列的数据类型，转换成Java类型
			String attrType = config.getString(columnEntity.getDataType(), "unknowType");
			columnEntity.setAttrType(attrType);

			// 是否主键
			if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
				tableEntity.setPk(columnEntity);
			}

			columsList.add(columnEntity);
		}
		tableEntity.setColumns(columsList);

		// 没主键，则第一个字段为主键
		if (tableEntity.getPk() == null) {
			tableEntity.setPk(tableEntity.getColumns().get(0));
		}

		// 设置velocity资源加载器
		Properties prop = new Properties();
		prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
		//Velocity.init(prop);
		
		freemarker.template.Configuration cfg = new freemarker.template.Configuration();

       // String path = System.getProperty("user.dir")+"/template/";
        try {
        		//设定去哪里读取相应的ftl模板文件
        		//File cfgFile = ClassLoader.getSystemResource("template");
        		cfg.setClassLoaderForTemplateLoading(ClassLoader.getSystemClassLoader(),"template");
			//cfg.setDirectoryForTemplateLoading(cfgFile);
			//cfg.setTemplateLoader(templateLoader);
			cfg.setDefaultEncoding("UTF-8");
			
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
		
		// 封装模板数据
		Map<String, Object> map = new HashMap<>();
		map.put("tableName", tableEntity.getTableName());
		map.put("comments", tableEntity.getComments());
		map.put("pk", tableEntity.getPk());
		map.put("className", tableEntity.getClassName());
		map.put("classname", tableEntity.getClassname());
		map.put("pathName", tableEntity.getClassname().toLowerCase());
		map.put("columns", tableEntity.getColumns());
		map.put("basePackage", config.getString("basePackage"));
		map.put("platPackage", config.getString("platPackage"));
		map.put("modulePackage", config.getString("modulePackage"));
		map.put("author", config.getString("author"));
		map.put("email", config.getString("email"));
		map.put("datetime", MyDateUtils.format(new Date(), MyDateUtils.DATE_TIME_PATTERN));
		//VelocityContext context = new VelocityContext(map);

		// 获取模板列表
		List<String> templates = getTemplates();
		for (String template : templates) {
			// 渲染模板
			StringWriter sw = new StringWriter();
			
			//template.process(paramMap, writer);
			try {
				Template tpl = cfg.getTemplate(template,"UTF-8");
			
				tpl.process(map, sw);
			
				// 添加到zip
				zip.putNextEntry(
						new ZipEntry(getFileName(template, tableEntity.getClassName(), config.getString("basePackage"),
								config.getString("modulePackage"), config.getString("platPackage"))));
				IOUtils.write(sw.toString(), zip, "UTF-8");
				IOUtils.closeQuietly(sw);
				zip.closeEntry();
			} catch (IOException e) {
				throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
			}catch (Exception e) {
				throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
			}
		}
	}

	/**
	 * 列名转换成Java属性名
	 */
	public static String columnToJava(String columnName) {
		return WordUtils.capitalizeFully(columnName, new char[] { '_' }).replace("_", "");
	}

	/**
	 * 表名转换成Java类名
	 */
	public static String tableToJava(String tableName, String tablePrefix) {
		if (StringUtils.isNotBlank(tablePrefix)) {
			tableName = tableName.replace(tablePrefix, "");
		}
		return columnToJava(tableName);
	}

	/**
	 * 获取配置信息
	 */
	public static Configuration getConfig() {
		try {
			return new PropertiesConfiguration("generator.properties");
		} catch (ConfigurationException e) {
			throw new RRException("获取配置文件失败，", e);
		}
	}

	/**
	 * 获取文件名
	 */
	public static String getFileName(String template, String className, String packageName, String moduleName,
			String platPackage) {
		String packagePath = "main" + File.separator + "java" + File.separator;
		if (StringUtils.isNotBlank(packageName)) {
			packagePath += packageName.replace(".", File.separator) + File.separator;
		}

		if (template.contains("Entity.java.vm")) {
			return packagePath + "entity" + File.separator + moduleName + File.separator + className + "Entity.java";
		}

		if (template.contains("Dao.java.vm")) {
			return packagePath + platPackage + File.separator + moduleName+ File.separator + "dao" + File.separator + className + "Dao.java";
		}

		if (template.contains("Service.java.vm")) {
			return packagePath + platPackage + File.separator + moduleName + File.separator + "service" + File.separator + className + "Service.java";
		}

		if (template.contains("ServiceImpl.java.vm")) {
			return packagePath + platPackage + File.separator + moduleName + File.separator + "service" + File.separator + "impl" + File.separator
					+ className + "ServiceImpl.java";
		}

		if (template.contains("Controller.java.vm")) {
			return packagePath + platPackage + File.separator + moduleName + File.separator + "controller" + File.separator + className
					+ "Controller.java";
		}

		if (template.contains("Dao.xml.vm")) {
			return "main" + File.separator + "resources" + File.separator + "mapper" + File.separator + platPackage
					+ File.separator + moduleName + File.separator + className + "Dao.xml";
		}

		if (template.contains("list.html.vm")) {
			return "main" + File.separator + "resources" + File.separator + "static" + File.separator + moduleName
					+ File.separator + className.toLowerCase() + ".html";
		}

		if (template.contains("list.js.vm")) {
			return "main" + File.separator + "resources" + File.separator + "static" + File.separator + moduleName
					+ File.separator + "js" + File.separator + className.toLowerCase()
					+ ".js";
		}

		if (template.contains("menu.sql.vm")) {
			return className.toLowerCase() + "_menu.sql";
		}

		return null;
	}
}
